{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,4,7,7],[8,4,8,7],[33,1,33,3],[30,1,30,3],[3,1,3,2],[5,6,5,7],[3,6,4,7],[32,1,32,3],[29,1,29,3],[35,1,35,3],[51,1,55,7],[20,1,20,3],[21,1,21,3],[24,1,24,3],[28,1,28,3],[22,1,22,3],[23,1,23,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[37,1,37,3],[31,1,31,3],[36,1,36,3],[34,1,34,3]]}
[]
[null,"Complete Patient Record Report for Vision 3"]
[]
[null,"Search Event Date Range",null,null,null,null,"Enter \nPatient Identifier"]
[null,"FROM","TO"]
[null,"1900-01-01","2018-11-12T09:42:57"]
[]
[null,null,null,null,"Enter Password"]
[]
[]
[null,"This will compile all the medical record data within the date period provided for a single patient"]
[null,"It will create a password protected file, and this password will need to be entered to view the information"]
[null,"The default folder location where the file is saved to is - P:\\Extract\\$PATIENT RECORD"]
[null,"Password Validation:"]
[null,"Password must contain at least 8 characters, 1 number, 1 lowercase letter, and 1 uppercase letter"]
[null,"Note:"]
[null,"This is NOT an audit report, it will only compile currently active data (lised below) within the data range."]
[]
[null,"Search Information"]
[null,"If there is no data for one of the subject areas below the worksheet will not be created"]
[null,"Data tables searched include the below"]
[null,"All Significant Medical History (Priority 1 or 2)"]
[null,"All Problems"]
[null,"All Allergies (Drug and Non drug)"]
[null,"All Currently Active Repeat Medication"]
[null,"Issued Medication"]
[null,"Referrals"]
[null,"Requests"]
[null,"Investigations"]
[null,"Immunisations"]
[null,"Correspondence"]
[null,"Attachments"]
[null,"Medication review"]
[null,"eMed3"]
[null,"Notepad"]
[null,"Lifestyle & Examination Findings"]
[null,"All other Clinical codes 0-9, A-Z (excluding the above) in date range"]
[null,"Consultation encounters"]
[]
[null,"Consult_id: This is the consultation encounter"]
[]
[null,"Current Version: 1.0"]
[null,"Last updated: 09/11/2018"]
[null,"Email: bradley.sieve@visionhealth.co.uk"]
[]
[null,"NOTE:"]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[]
[null,"Disclaimer"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]

{"sheet":"Lists","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Option Buttons"]
[null,null,null,2]